﻿CREATE TABLE [dbo].[OrderF] (
    [Id]                 INT              IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [OId]                UNIQUEIDENTIFIER CONSTRAINT [DF_FOrder_OId] DEFAULT (newid()) ROWGUIDCOL NULL,
    [CusName]            NVARCHAR (50)    NULL,
    [CusPerson]          NVARCHAR (50)    NULL,
    [CusPersonTel]       NVARCHAR (50)    NULL,
    [CusDescription]     NVARCHAR (500)   NULL,
    [CusEstimate]        NVARCHAR (50)    NULL,
    [TypeId]             INT              NULL,
    [TypeName]           NVARCHAR (50)    NULL,
    [Salesman]           NVARCHAR (50)    NULL,
    [SalesmanAccount]    NVARCHAR (50)    NULL,
    [TradeDate]          DATETIME         NULL,
    [CreateDate]         DATETIME         NULL,
    [YingShouPrice]      DECIMAL (18, 2)  NULL,
    [ShiShouPrice]       DECIMAL (18, 2)  NULL,
    [Discount]           NVARCHAR (50)    NULL,
    [PaymentTypeId]      INT              NULL,
    [PaymentType]        NVARCHAR (50)    NULL,
    [BankId]             INT              NULL,
    [Bank]               NVARCHAR (50)    NULL,
    [PaymentDescription] NVARCHAR (50)    NULL,
    [OtherDescription]   NVARCHAR (50)    NULL,
    [DepId]              INT              NULL,
    [CompanyId]          INT              NULL,
    [StateId]            INT              NULL,
    [FinanceRenlingDate] DATETIME         NULL,
    [IsGreen]            BIT              NULL,
    [TrackKfAccount]     NVARCHAR (50)    NULL,
    [TrackKfName]        NVARCHAR (50)    NULL,
    [TrackKfDepId]       INT              NULL,
    CONSTRAINT [PK_FOrder] PRIMARY KEY CLUSTERED ([Id] ASC)
);

